Skip to main content

🔄 Update Record

The Update Record action allows you to modify existing records in a database table by specifying new values for selected columns, filtered by conditions.

Configuration​

  • Name: Enter a descriptive name for the update record action.
  • Select Source: Choose the data source or connection where the record resides.
  • Select Schema: Specify the database schema containing the target table.
  • Select Table: Choose the table where the record(s) to update exist.
  • Select Column: Define one or more columns and their new values for the update. For each column:
    • Select the column name.
    • Enter the new value or use an expression (fx) to dynamically assign it.
    • Use the plus (+) button to add additional columns or the trash icon to remove.
  • Filter: Apply filter conditions to specify which records should be updated.
    • Use the Select Filter button to add filtering criteria.
    • Add or remove filters using the plus (+) and delete (x) buttons.

Features​

  • Updates multiple columns in existing records.
  • Supports dynamic value assignment with expressions.
  • Allows precise targeting of records via filters.
  • Works with various data sources and schemas.

Use Cases​

  • Modify user information such as email or status.
  • Update order statuses or transaction details.
  • Correct or adjust data entries based on workflow logic.
  • Perform batch updates on filtered records.

Notes​

  • Ensure the selected source, schema, and table exist and are accessible.
  • Validate filters to avoid unintended updates.
  • Use expressions to calculate or determine new values dynamically.

Tip: Combine Update Record with Get Record and Filter array actions to create complex data update workflows.